Aggregate Maintenance for Data Warehousing in Informix Red Brick Vista
نویسندگان
چکیده
منابع مشابه
Storage Layout and I/O Performance Tuning for IBM® Red Brick® Data Warehouse
Although Red Brick performance depends primarily on the logical database design, the placement and allocation of data files in the disk subsystem is another significant performance factor. There are many choices in the configuration and design of the physical database layout. This article reviews best practices propagated by storage and database vendors and presents measurements that compare st...
متن کاملConcurrency in the Data Warehouse
When a data warehouse is loaded at night and queried during the day, there is no requirement for concurrent update and querying. However there are a number of situations where concurrency is needed: trickle feed applications, correcting exception data from the nightly load, the narrowing load window. The end point of the narrowing load window is a data warehouse that is available 7x24. Query Pr...
متن کاملUsing Materialized Views To Speed Up Data Warehousing
Running analytical queries directly against the huge raw data volume of a data warehouse results in unacceptable query performance. The solution to this problem is storing materialized views in the warehouse, which pre-aggregate the data and thus avoid raw data access and speed up queries. In this paper, at first the problems concerning the selection of the right pre-aggregations and their util...
متن کاملLaboratory Evaluation of Asphalt Concrete Prepared with Over Burnt Brick Aggregate Treated by Zycosoil
Asphaltic concrete for pavement construction in India are produced by using crushed stone, gravels etc. as aggregate. In north-Eastern region of India, there is a scarcity of stone aggregate. Therefore the road engineers are always in search of an optional material as aggregate which can replace the regularly used material. The purpose of this work was to evaluate the utilization of substandard...
متن کاملAn Integrated Aggregate Production Planning Model with Two-Phase Production System and Maintenance Costs
Aggregate production planning (APP) is one of the most important issues carried out in manufacturing environments which seeks efficient planning, scheduling and coordination of all production activities that optimizes the company's objectives. In this paper, we develop a mixed integer linear programming (MILP) model for an integrated aggregate production planning system with closed loop supply ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2001